How to: Display an ampersand (&) in a label on a report.
Solution:
Type two ampersands (&) in the label box in Design view.
NOTE: The ampersand (&) symbol is a special character in Access used for underlining letters.
1) If the Database window is not active, activate the Database window.
2) Click the 'Report' tab.
3) Select the desired report. (The report highlights.)
4) Click 'Design'.
5) Click in the label where the ampersand is to appear.
6) Type two ampersands in the label box.
EXAMPLE: Ben && Jenny's
